package com.chazz.dao;

import com.chazz.Do.KeyValue;
import com.chazz.entity.Brand;
import com.chazz.entity.Discount;
import com.chazz.entity.Goods;
import com.chazz.entity.Sku;
import java.util.List;

import java.sql.SQLException;

/**
 * 描述:商品通用信息查询DAO
 *
 * @author Chazz
 * @create 2020-09-24 19:19
 */
public interface SkuDao {

    Goods selectGoods(Integer goodsId);
    /**
     * description: selectSku 通过商品id查询商品通用信息 <br>
     * version: 1.0 <br>
     * date: 2020/9/24 19:28 <br>
     * author: Chazz <br>
     * @param goodsId 商品id
     * @return com.chazz.entity.Sku 商品通用信息数据对象
     */
    Sku selectSku(Integer goodsId);

    /**
     * description: seclectBrand 通过品牌id查询品品牌信息<br>
     * version: 1.0 <br>
     * date: 2020/9/24 19:33 <br>
     * author: Chazz <br>
     * @param brandId 品牌id
     * @return com.chazz.entity.Brand 品牌信息对象
     */
    Brand seclectBrand(Integer brandId);
    /**
     * description: attributes 通过类别id查询改类别拥有的所有属性<br>
     * version: 1.0 <br>
     * date: 2020/9/24 22:21 <br>
     * author: Chazz <br>
     * @param categoryId 类别id
     * @return java.util.Map<java.lang.String,java.lang.String> 属性map集合
     */
    List<KeyValue> attributes(Integer categoryId);

    Discount selectDiscount(Integer categoryId);



    /**
     * @param goodsID
     * @return
     * @author Woo
     */
    public Sku findSku(int goodsID) throws SQLException;




}
